home *** CD-ROM | disk | FTP | other *** search
/ Winzipper / Winzipper_ISO.iso / programming / oracle7 7.2 / DB / RDBMS72 / CREATEDB.SQL < prev    next >
Encoding:
Text File  |  1995-10-12  |  783 b   |  23 lines
  1. REM 
  2. REM $Header: createdb.sql 1.2 94/10/19 09:31:34 gdudey Osd<desktop/netware> $ Copyr (c) 1994 Oracle
  3. REM
  4. set TERMOUT OFF
  5. spool %RDBMS72%\TRACE\build.log
  6. connect internal@2:
  7. startup nomount pfile=%ORACLE_HOME%\DATABASE\inst.ora
  8. create controlfile reuse set database oracle
  9. datafile '%RDBMS_FILES%\sys1orcl.ora',
  10.          '%RDBMS_FILES%\tmp1orcl.ora',
  11.          '%RDBMS_FILES%\rbs1orcl.ora',
  12.          '%RDBMS_FILES%\usr1orcl.ora'
  13. logfile '%RDBMS_FILES%\log1orcl.ora' size %starterl_size%k,
  14.         '%RDBMS_FILES%\log2orcl.ora' size %starterl_size%k resetlogs;
  15. alter database oracle open resetlogs;
  16. update props$ set VALUE$ = '%starter_charset%' where NAME = 'NLS_CHARACTERSET';
  17. commit
  18. alter user SYS identified by %product_id%;
  19. commit
  20. shutdown
  21. spool off
  22. exit
  23. /